ProteanBeing
02-02-2008, 06:04 PM
I have created a hidden button that hides / shows (toggles) the menu and toolbars so that I can edit the file when I need to. I would like to toggle the row and column headers to but I can't seem to make it work. This is what I was trying to do:
dim MyTabs as worksheets
for each MyTabs in workbook
MyTabs.DisplayHeadings = false
next MyTabs
I get an Object Required error.
What am I doing wrong?
dim MyTabs as worksheets
for each MyTabs in workbook
MyTabs.DisplayHeadings = false
next MyTabs
I get an Object Required error.
What am I doing wrong?