Hidding ALL sheets

  • Thread starter Thread starter rvExcelTip
  • Start date Start date
R

rvExcelTip

Is it posible to hide ALL worksheets and Charts in a workbook?

I want to control them through a user defined form
 
Save the file as an addin (xla file, downmost filetype in SaveAs) and
everything is hidden. ...But then you must make your macros available,
either with a custom menu or a custom toolbar. See John Walkebnach's page
http://j-walk.com/ss/excel/tips/tip90.htm on how to do this.

HTH. Best wishes Harald
 
Back
Top