Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when loading a programme from a tool bar
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Tool Pack addin into Excel and it is not loading | Excel Discussion (Misc queries) | |||
run programme error occuring | Excel Worksheet Functions | |||
error in programme | Excel Discussion (Misc queries) | |||
Error message Microsoft Graph is part of another programme | Setting up and Configuration of Excel | |||
Tool bar keeps loading | Excel Discussion (Misc queries) |