Re: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

2015-01-22 Thread dza49
Excellent, thank you sir!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

2015-01-21 Thread Paul Schreiner
, January 21, 2015 12:32 PM Subject: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working Hello, i'm having trouble with a macro that i've sent up to: 1) unprotect a sheet with a password 2) do some filtering and set a print area 3) apply the password again Looks like

$$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

2015-01-21 Thread dza49
Hello, i'm having trouble with a macro that i've sent up to: 1) unprotect a sheet with a password 2) do some filtering and set a print area 3) apply the password again Looks like steps 1 and 2 are working fine but step 3 isn't working. After running the marco I can click the Unprotect Sheet