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

I hope this is what you mean:

Public Sub LoadUnitLinkedLifeCalculationSpreadsheet()

Workbooks.Open FileName:="j:\bts\actl\Unit Linked Life Calculations\Unit
Linked Life Calculations.xls"

End Sub

To get the sheet unprotected I changed the code in This Workbook to:

Private Sub Workbook_Open()

frmSplash.Show
Worksheets("ABS").Select
Calculate

If Range("InOrOut") = "BTS" Then Application.Run "BTS_Access_Start"


End Sub

Where "BTS_Access_Start" is the macro that does the whole
unprotecting/shape-moving.

It also works fine when I ok the error messages and run manually.




"Vacation's Over" wrote:

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