LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default My Macros will not work after I protect my document.

Mike... did you ever find out what to do to be able to run macros on a
password protected workbook? Would appreciate your help before I go crazy!

Roger.


"mike" wrote:

sry for the off topic Samantha . . .

I was using 2007 when I found that my macro wouldn't run on a protected
workbook. It took me days to figure out what was goin wrong and several hours
in this forum - No one was able to help me.

"Gord Dibben" wrote:

Mike

Is this a feature of Excel 2007?

In earlier version. macros will run on protected workBOOKS


Gord Dibben MS Excel MVP


On Tue, 24 Jun 2008 13:41:01 -0700, mike wrote:

In my experience, if you protect the workBOOK, macros will not run. They
should still run with a protected worksheet though.

"Samantha" wrote:

Is there any way to make macros work once my document is protected? If so how?



 
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 can i protect a document so nobody can delete it jenniss Excel Discussion (Misc queries) 1 January 14th 05 11:53 PM
how can i protect a document so nobody can delete it jenniss Excel Discussion (Misc queries) 1 January 14th 05 12:30 PM
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM
Best way to protect sheets and document. Luong[_2_] Excel Programming 1 June 29th 04 02:18 PM
Password protect an Excel document Paul B[_7_] Excel Programming 1 September 17th 03 06:47 PM


All times are GMT +1. The time now is 06:49 AM.

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"