Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
No Name
 
Posts: n/a
Default Restoring toolbar

In attempting to learn vba macros I downloaded one that creates a custom
toolbar. it has changed / eliminated my top row toolbar (file, edit
view,tools, help ) I cant find an option to restore back to default
settings.
Thanks in advance
Duane

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default Restoring toolbar

Go into the VBIDE, and in the immediate window enter

Application.Commandbars("Worksheet Menu Bar").Enabled = True

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
In attempting to learn vba macros I downloaded one that creates a custom
toolbar. it has changed / eliminated my top row toolbar (file, edit
view,tools, help ) I cant find an option to restore back to default
settings.
Thanks in advance
Duane



  #3   Report Post  
Posted to microsoft.public.excel.newusers
No Name
 
Posts: n/a
Default Restoring toolbar

thanks

"Bob Phillips" wrote in message
...
Go into the VBIDE, and in the immediate window enter

Application.Commandbars("Worksheet Menu Bar").Enabled = True

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



wrote in message
...
In attempting to learn vba macros I downloaded one that creates a custom
toolbar. it has changed / eliminated my top row toolbar (file, edit
view,tools, help ) I cant find an option to restore back to default
settings.
Thanks in advance
Duane




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restoring formulas after deleting range names KDJ Excel Worksheet Functions 3 January 2nd 07 06:24 PM
Restoring the File option on the top Menu bar of Excel. Smitty50 Excel Discussion (Misc queries) 3 October 17th 06 04:45 PM
Restoring fields in a pivot table Philip Excel Worksheet Functions 2 August 31st 06 07:01 PM
Adjusting toolbar size, restore toolbar Josh M Excel Discussion (Misc queries) 1 January 18th 06 06:17 PM
restoring column labels Excel 2002 Paul B Excel Discussion (Misc queries) 3 April 6th 05 09:29 PM


All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"