Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control buttons missing
Hello,
I am sure this is something obvious but its driving me mad.... I have a workbook with control buttons on several sheets to run various macros. It all looks fine to me and also for another user, but for one particular guy when he opens the workbook the buttons on the sheet first displayed appear momentarily and then disappear, and then there are no buttons shown on any sheets. He has his macro security level set to medium, like the rest of us, and clicks the enable macros button when he opens the workbook. What is even more odd is that once or twice he has opened the spreadsheet and the buttons are there. We are on Excel 2003. If anyone can enlighten me on what's going on it would be much appreciated. Thanks. Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control buttons missing
Thanks. Unfortuately he isn't seeing the problem today but next time he does
I'll check this. Thanks for your help. Chris "OssieMac" wrote: On the machine that is not working try menu item Tools, Options, View tab and under objects set to show all "ChrisO" wrote: Hello, I am sure this is something obvious but its driving me mad.... I have a workbook with control buttons on several sheets to run various macros. It all looks fine to me and also for another user, but for one particular guy when he opens the workbook the buttons on the sheet first displayed appear momentarily and then disappear, and then there are no buttons shown on any sheets. He has his macro security level set to medium, like the rest of us, and clicks the enable macros button when he opens the workbook. What is even more odd is that once or twice he has opened the spreadsheet and the buttons are there. We are on Excel 2003. If anyone can enlighten me on what's going on it would be much appreciated. Thanks. Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control buttons missing
As it is intermittent, it is possible that the option is altered by another
macro being run by the user because if set in a maco it remains set until changed by the user or in a macro. If it persists you could try using a macro procedure named "Sub Auto_Open()" for which I cannot find documented in help but a sub named as this will run each time the workbook is opened. Simply record a macro when setting the option to get the syntax and insert it in the Auto_Open sub. Additional tip "Sub Auto_Close()" runs on shutdown of the workbook. "ChrisO" wrote: Thanks. Unfortuately he isn't seeing the problem today but next time he does I'll check this. Thanks for your help. Chris "OssieMac" wrote: On the machine that is not working try menu item Tools, Options, View tab and under objects set to show all "ChrisO" wrote: Hello, I am sure this is something obvious but its driving me mad.... I have a workbook with control buttons on several sheets to run various macros. It all looks fine to me and also for another user, but for one particular guy when he opens the workbook the buttons on the sheet first displayed appear momentarily and then disappear, and then there are no buttons shown on any sheets. He has his macro security level set to medium, like the rest of us, and clicks the enable macros button when he opens the workbook. What is even more odd is that once or twice he has opened the spreadsheet and the buttons are there. We are on Excel 2003. If anyone can enlighten me on what's going on it would be much appreciated. Thanks. Chris |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control buttons missing
Thanks OssieMac, I've added this in.
"OssieMac" wrote: As it is intermittent, it is possible that the option is altered by another macro being run by the user because if set in a maco it remains set until changed by the user or in a macro. If it persists you could try using a macro procedure named "Sub Auto_Open()" for which I cannot find documented in help but a sub named as this will run each time the workbook is opened. Simply record a macro when setting the option to get the syntax and insert it in the Auto_Open sub. Additional tip "Sub Auto_Close()" runs on shutdown of the workbook. "ChrisO" wrote: Thanks. Unfortuately he isn't seeing the problem today but next time he does I'll check this. Thanks for your help. Chris "OssieMac" wrote: On the machine that is not working try menu item Tools, Options, View tab and under objects set to show all "ChrisO" wrote: Hello, I am sure this is something obvious but its driving me mad.... I have a workbook with control buttons on several sheets to run various macros. It all looks fine to me and also for another user, but for one particular guy when he opens the workbook the buttons on the sheet first displayed appear momentarily and then disappear, and then there are no buttons shown on any sheets. He has his macro security level set to medium, like the rest of us, and clicks the enable macros button when he opens the workbook. What is even more odd is that once or twice he has opened the spreadsheet and the buttons are there. We are on Excel 2003. If anyone can enlighten me on what's going on it would be much appreciated. Thanks. Chris |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control buttons missing
We saw the problem again this morning, and checked that the excel option
below was set correctly (it was). Our theory now is that it occurs when the user's IBM ThinkPad is connected to a projector, which needs display settings to be changed. I've no idea why this seems to result in the excel buttons disappearing or why it only seems to affect this one user (a couple of other ThinkPad users are OK). Any theories on what is going on, and how to overcome it would be very welcome! "ChrisO" wrote: Thanks OssieMac, I've added this in. "OssieMac" wrote: As it is intermittent, it is possible that the option is altered by another macro being run by the user because if set in a maco it remains set until changed by the user or in a macro. If it persists you could try using a macro procedure named "Sub Auto_Open()" for which I cannot find documented in help but a sub named as this will run each time the workbook is opened. Simply record a macro when setting the option to get the syntax and insert it in the Auto_Open sub. Additional tip "Sub Auto_Close()" runs on shutdown of the workbook. "ChrisO" wrote: Thanks. Unfortuately he isn't seeing the problem today but next time he does I'll check this. Thanks for your help. Chris "OssieMac" wrote: On the machine that is not working try menu item Tools, Options, View tab and under objects set to show all "ChrisO" wrote: Hello, I am sure this is something obvious but its driving me mad.... I have a workbook with control buttons on several sheets to run various macros. It all looks fine to me and also for another user, but for one particular guy when he opens the workbook the buttons on the sheet first displayed appear momentarily and then disappear, and then there are no buttons shown on any sheets. He has his macro security level set to medium, like the rest of us, and clicks the enable macros button when he opens the workbook. What is even more odd is that once or twice he has opened the spreadsheet and the buttons are there. We are on Excel 2003. If anyone can enlighten me on what's going on it would be much appreciated. Thanks. Chris |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control buttons missing
Check out this thread http://www.excelforum.com/showthread.php?t=580053 *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing buttons!? | Excel Discussion (Misc queries) | |||
Missing Buttons | Excel Discussion (Misc queries) | |||
missing buttons | Excel Programming | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Control Buttons vs. Command Buttons | Excel Programming |