Google
 
Webnews.only-4-geeks.com
Interesting places
news.only-4-geeks.com Forum Index » Excel

Shift key to disable macros

 
Jump to:  
 
Jarryd
PostPosted: Tue Jun 10, 2008 8:23 am    Post subject: Shift key to disable macros
       
Hi,

I thought that the by holding down teh shift key when opening excel macros
would be disabled. However, I have a file that has some code in thhe
Workbook_Open() event. When I open Excel holding down the shift key (left
one, the right one, or both!!) it still runs the code.

Why?

TIA,

Jarryd
 

 
Jarryd
PostPosted: Tue Jun 10, 2008 8:33 am    Post subject: Re: Shift key to disable macros
       
Aha!!!! You have to open the file from within Excel while holding down the
shift key..... ahhhhhh.

Jarryd

"Jarryd" <jarryd@community.nospam> wrote in message
news:uuJ16RuyIHA.3968@TK2MSFTNGP04.phx.gbl...
Quote:
Hi,

I thought that the by holding down teh shift key when opening excel macros
would be disabled. However, I have a file that has some code in thhe
Workbook_Open() event. When I open Excel holding down the shift key (left
one, the right one, or both!!) it still runs the code.

Why?

TIA,

Jarryd
 

Page 1 of 1 .:.

Google
 
Webnews.only-4-geeks.com

Windows Update | C++ | C | PHP | JavaScript | Photoshop | Programming | Windows 2000 | Python | Windows XP | Object | Flash | Flash - ActionScript | Paint Shop Pro | Excel | PowerPoint | Access | Word | Windows 98 | Internet Explorer 6.0 | CorelDraw12 | Java | XML | asm x86 | Linux Mandrake | Linux RedHat | Outlook |  | news from newsgroups |_ | s

Web Templates

Awesome Website Templates ©

Yahoo mieszkanie Poznań nowe projekty domów Wózki paletowe homeopatia vichy