Macro not running with worksheet protection

ExcelNovice · May 14th, 2002, 08:59 PM

Why are my macro not running when I protect my worksheet? Did I do something wrong or is that just how it is?

It's a simple macro (well a simple number of macros). They are all sort macros.

Can I get the macro to run when the sheet is protected? If so please share the "how to".

Thanks in advance

Tom Schreiner · May 14th, 2002, 09:05 PM

Is it not running at all or running and producing an error?

If no password



ActiveSheet.Unprotect 'At the beginning of your procedure...



ActiveSheet.Protect 'at the end

If there is a password



ActiveSheet.Unprotect Password:="YourPassword"



ActiveSheet.Protect Password:="YourPassword"

Tom

[ This Message was edited by: TsTom on 2002-05-14 20:06 ]

Mark O'Brien · May 14th, 2002, 09:06 PM

Does the macro in question try to select any "locked" cells on the protected worksheet? or does it try to format any of these cells, or does it try to look at the locked cells in a funny way? If the answer to these is "yes", then you'll need to un protect your worksheet before running your macro, have a quick search on this site on how to do this using VBA, it's pretty simple.

If the answer was "no" to any of those questions, except for the last one, then paste as much of your code as is necessary to let us see if we can spot the problem.

(note:: All cells are "locked" by default)

Mark O'Brien · May 14th, 2002, 09:08 PM

Quote:

If the answer to these is "yes", then you'll need to un protect your worksheet before running your macro, have a quick search on this site on how to do this using VBA, it's pretty simple.

..or you could just follow TS "Speedy Fingers" Tom's advice.

ExcelNovice · May 14th, 2002, 09:10 PM

Amazing!! It worked like hell!

You guys are good....thanks Tom.

May 14th, 2002, 09:05 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Is it not running at all or running and producing an error? If no password ActiveSheet.Unprotect 'At the beginning of your procedure... ActiveSheet.Protect 'at the end If there is a password ActiveSheet.Unprotect Password:="YourPassword" ActiveSheet.Protect Password:="YourPassword" Tom [ This Message was edited by: TsTom on 2002-05-14 20:06 ]

May 14th, 2002, 09:06 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Does the macro in question try to select any "locked" cells on the protected worksheet? or does it try to format any of these cells, or does it try to look at the locked cells in a funny way? If the answer to these is "yes", then you'll need to un protect your worksheet before running your macro, have a quick search on this site on how to do this using VBA, it's pretty simple. If the answer was "no" to any of those questions, except for the last one, then paste as much of your code as is necessary to let us see if we can spot the problem. (note:: All cells are "locked" by default) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 08:59 PM	#1
ExcelNovice Board Regular Join Date: May 2002 Posts: 485	Why are my macro not running when I protect my worksheet? Did I do something wrong or is that just how it is? It's a simple macro (well a simple number of macros). They are all sort macros. Can I get the macro to run when the sheet is protected? If so please share the "how to". Thanks in advance

May 14th, 2002, 09:10 PM	#5
ExcelNovice Board Regular Join Date: May 2002 Posts: 485	Amazing!! It worked like hell! You guys are good....thanks Tom.