ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Active X Command Buttons Disappear (https://www.excelbanter.com/excel-programming/372889-active-x-command-buttons-disappear.html)

Steve[_85_]

Active X Command Buttons Disappear
 
Not sure if this is the correct newsgroup... My apologies if it isn't.

Occasionally, all the command buttons disappear from all worksheets in the
workbook after the user has clicked on the "Enable Macros" button when first
opening a workbook containing macros. The first time this happened, the
user had the workbook open, then un-docked from the docking station, and
took the laptop to another room, where it was reconnected to the network
using a cable. He then exited the workbook, and reopened. He could see the
buttons until he clicked the "Enable Macros" button, then they disappeared.

The buttons did not reappear until the user rebooted the laptop in the
docking station. The user has since noticed that the buttons sometimes
disappear upon opening even when the laptop is in the docking station.

My initial thought was that he was approaching a memory limit in Excel. He
doesn't remember what else was running on his laptop at the time.

Has anyone experienced similar issues? Any help will be greatly
appreciated.

Thanks,
Steve



Jim Cone

Active X Command Buttons Disappear
 
Steve,
Maybe...
http://support.microsoft.com/default...b;EN-US;838910
"Controls move to the left of the worksheet in Microsoft Excel 2002"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Steve"
wrote in message
Not sure if this is the correct newsgroup... My apologies if it isn't.

Occasionally, all the command buttons disappear from all worksheets in the
workbook after the user has clicked on the "Enable Macros" button when first
opening a workbook containing macros. The first time this happened, the
user had the workbook open, then un-docked from the docking station, and
took the laptop to another room, where it was reconnected to the network
using a cable. He then exited the workbook, and reopened. He could see the
buttons until he clicked the "Enable Macros" button, then they disappeared.

The buttons did not reappear until the user rebooted the laptop in the
docking station. The user has since noticed that the buttons sometimes
disappear upon opening even when the laptop is in the docking station.

My initial thought was that he was approaching a memory limit in Excel. He
doesn't remember what else was running on his laptop at the time.

Has anyone experienced similar issues? Any help will be greatly
appreciated.

Thanks,
Steve



Steve

Active X Command Buttons Disappear
 
Thanks Jim. I'll get back to the user to find out what version & SP of
Excel that he's using.


"Jim Cone" wrote in message
...
Steve,
Maybe...
http://support.microsoft.com/default...b;EN-US;838910
"Controls move to the left of the worksheet in Microsoft Excel 2002"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Steve"
wrote in message
Not sure if this is the correct newsgroup... My apologies if it isn't.

Occasionally, all the command buttons disappear from all worksheets in the
workbook after the user has clicked on the "Enable Macros" button when
first
opening a workbook containing macros. The first time this happened, the
user had the workbook open, then un-docked from the docking station, and
took the laptop to another room, where it was reconnected to the network
using a cable. He then exited the workbook, and reopened. He could see
the
buttons until he clicked the "Enable Macros" button, then they
disappeared.

The buttons did not reappear until the user rebooted the laptop in the
docking station. The user has since noticed that the buttons sometimes
disappear upon opening even when the laptop is in the docking station.

My initial thought was that he was approaching a memory limit in Excel.
He
doesn't remember what else was running on his laptop at the time.

Has anyone experienced similar issues? Any help will be greatly
appreciated.

Thanks,
Steve






All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com