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. |
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. |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 09:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com