LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Excel 2007: deleting macro from personal.xlsb

I am a complete novice with macros, but have been playing with some simple
examples.

I have a macro created that I want to delete, but when I navigate to
developer/macros and choose the macro, I am told I can't delete it because
it resides in the hidden personal macro workbook file (personal.xlsb). It
says to use the unhide command in order to delete the macro, but I can't
find that particular command.

Some unhide commands are at home/cells/format dropdown, but I don't see
anything relevant. There is no workbook choice. Not even a greyed out
workbook choice. Which might lead me to believe I have no hidden workbooks,
but nonetheless I get the message to unhide.

I see some hide choices at view/show-hide, but nothing relevant.

I also notice I have a blank worksheet at the end of my Excel file titled
simply "sheet 1". Is this related to macros and can it be deleted?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to make personal.xlsb start in 2007 mithu Excel Discussion (Misc queries) 0 May 1st 07 06:42 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"