Post opening code from tool bar

Can we assume that the code for direct loading is in the Workshet_Open event?

"Muttley" wrote:

I've set up a macro so that it recognises if the user is from a pre-defined
group when you load the spreadsheet and automatically passwords-unprotects
and moves a few shapes about. If I load up the spreadsheet from the folder
it works fine.

However you can also load it up from a custom tool bar, but if I do this I
get an error
'-2147467259 (800004005)' Method 'select' of objct 'shape' failed
and the password un-protects fails.

From my limited knowledege, I am guessing that when accesing through the
custom menu it is not recognising which spreadsheet to run the password
unprotect macro on and so when it comes to move the shape it is still
password protected (or maybe can't even find the shape?) - can anyone throw
any light on this?

Thx