View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup,microsoft.public.excel,microsoft.public.excel.programming
Charlie G Charlie G is offline
external usenet poster
 
Posts: 5
Default custom toolbar looses buttons when closed

Hi all, I've crossposted to three groups as I'm not sure of the best
location. Apologies if this breaches protocol.

my custom excel toolbar (office97) with macros linked to 3 buttons worked
fine in Windows NT, but a recent enterprise wide upgrade to XP has resulted
in the buttons on the toolbar dissapearing each time Excel is restarted. I
understand this is because the C:\ drive is locked locked down to prevent
changes. While I understand this will be rectified, IT changes are slow in
our organisation.

I also understand this prevents me changing the default file locations and
startup in Tools, Options, general. The toolbar remains, but is empty. the
macros are still attached to the workbook.

Can anyone suggest a solution?

As I always run a Word document as well as Excel, I wondered if a macro in
the word document might be able to reset the appropriate settings and start
Excel automatically.

I look forward to any help or advice.

Charlie G