Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Error when trying to delete a macro...
I'm trying to get delete a macro, but I when I hit the delete button it gives
me this error: Cannot edit a macro on a hidden worksheet. Unhide the workbook using the Unhide Command. I've never heard of any "Unhide" command ... only hiding/unhiding rows and columns. |
#2
|
|||
|
|||
Try going to Format-Sheet-Unhide.
Regards, Paul "Currie" wrote in message ... I'm trying to get delete a macro, but I when I hit the delete button it gives me this error: Cannot edit a macro on a hidden worksheet. Unhide the workbook using the Unhide Command. I've never heard of any "Unhide" command ... only hiding/unhiding rows and columns. |
#3
|
|||
|
|||
Try Format--Sheet--Unhide. But there's a good chance the worksheet is
xlVeryHidden with code... ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Currie" wrote in message ... I'm trying to get delete a macro, but I when I hit the delete button it gives me this error: Cannot edit a macro on a hidden worksheet. Unhide the workbook using the Unhide Command. I've never heard of any "Unhide" command ... only hiding/unhiding rows and columns. |
#4
|
|||
|
|||
Unhide is "grayed" out. I cannot click it. Any other thoughts?
"Anne Troy" wrote: Try Format--Sheet--Unhide. But there's a good chance the worksheet is xlVeryHidden with code... ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Currie" wrote in message ... I'm trying to get delete a macro, but I when I hit the delete button it gives me this error: Cannot edit a macro on a hidden worksheet. Unhide the workbook using the Unhide Command. I've never heard of any "Unhide" command ... only hiding/unhiding rows and columns. |
#5
|
|||
|
|||
That means the worksheet is hidden using VBA. You should talk to the
developer of the workbook if you want to change it. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Currie" wrote in message ... Unhide is "grayed" out. I cannot click it. Any other thoughts? "Anne Troy" wrote: Try Format--Sheet--Unhide. But there's a good chance the worksheet is xlVeryHidden with code... ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Currie" wrote in message ... I'm trying to get delete a macro, but I when I hit the delete button it gives me this error: Cannot edit a macro on a hidden worksheet. Unhide the workbook using the Unhide Command. I've never heard of any "Unhide" command ... only hiding/unhiding rows and columns. |
#6
|
|||
|
|||
Try the Window menu to see if you have any hidden workbooks. Quite often
macros are stored in the Personal Workbook which is sometimes hidden. -- Sincerely, Michael Colvin "Currie" wrote: Unhide is "grayed" out. I cannot click it. Any other thoughts? "Anne Troy" wrote: Try Format--Sheet--Unhide. But there's a good chance the worksheet is xlVeryHidden with code... ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Currie" wrote in message ... I'm trying to get delete a macro, but I when I hit the delete button it gives me this error: Cannot edit a macro on a hidden worksheet. Unhide the workbook using the Unhide Command. I've never heard of any "Unhide" command ... only hiding/unhiding rows and columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
delete personal macro | Excel Discussion (Misc queries) | |||
Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
Cannot delete a macro | Excel Discussion (Misc queries) | |||
Macro to delete a macro | Excel Worksheet Functions |