Macros in protected sheets

[edmundo1971]

Hello people, I'm new to this so please excuse any simple questions.

My first question involves having macros work in password protected sheets. I want to have a button linked to a macro which basically unprotects the password protected sheet [without the user seeing it], selects a chart within the sheet to print and the reprotects the password protected sheet using the same passsword [again without the user seeing it].

The Excel version I'm using is 2007.

I'm afraid I can't post an example as Excel is on my work PC. And my work PC's browser is years out of date :-)

One other thing - the workbook in which the sheet is may need to be put into shared user allowing more than one person to update it at any time. This too would be required to be password protected so if anyone suggest a solution for this too I'd be very happy.

Thanks!!!

Ed

[AndyLitch]

The macro for unprotecting etc would run like this

Sub MyMacro()
ActiveSheet.Unprotect Password:="passme"
'Your code for chart manipulation here
'You can record the chart macro and move the code here
ActiveSheet.Protect Password:="passme"
End Sub

[edmundo1971]

Hello!!!

The macro works great - many thanks!!! One thing though, it doesn't work when the spreadsheet is in shared use - any suggestioins???

Thanks

Ed

[AndyLitch]

I think all macro's are disabled on shared drives...<-- I'm not too experienced on the subject though.
Maybe you can ask about that on a different thread ...

[edmundo1971]

Will do, thanks for your time.