Removing and Restoring Excel toolbars
 

I am considering whether to completely remove all excel tool bars in an
application that I'm working on. i.e remove toolbars when workbook is
opened and restore the original toolbars on close.

Having previously 'lost' toolbars myself, is this a dangerous practice
given the variety of excel versions out in user land? What is
considered 'best practice' in this regard?

Thanks to everyone who has guided me so far through my first VBA
project, very much appreciated from this 'down under' VBA novice.

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=498977

Removing and Restoring Excel toolbars
 

There is no great problem that I know of as long as you track what is
removed, and put them all back at the end.

The things to be aware of is whether you still allow access to Excel
generally. If so, you should restore them whenever you workbook is
deactivated, as well as on closedown, and then hide them when yours is
activated, as well as on open.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"peter.thompson"
wrote in
message news:peter.thompson.219d8m_1136626802.112@excelfor um-nospam.com...

I am considering whether to completely remove all excel tool bars in an
application that I'm working on. i.e remove toolbars when workbook is
opened and restore the original toolbars on close.

Having previously 'lost' toolbars myself, is this a dangerous practice
given the variety of excel versions out in user land? What is
considered 'best practice' in this regard?

Thanks to everyone who has guided me so far through my first VBA
project, very much appreciated from this 'down under' VBA novice.

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile:
http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=498977

Removing and Restoring Excel toolbars
 

hi Peter

You can find a few examples here
http://www.rondebruin.com/menuid.htm

If you need more help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"peter.thompson" wrote in message
news:peter.thompson.219d8m_1136626802.112@excelfor um-nospam.com...

I am considering whether to completely remove all excel tool bars in an
application that I'm working on. i.e remove toolbars when workbook is
opened and restore the original toolbars on close.

Having previously 'lost' toolbars myself, is this a dangerous practice
given the variety of excel versions out in user land? What is
considered 'best practice' in this regard?

Thanks to everyone who has guided me so far through my first VBA
project, very much appreciated from this 'down under' VBA novice.

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=498977

Removing and Restoring Excel toolbars
 

Thanks for the advice & help guys, I'll start experimenting

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=498977