ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unhidding sheets (https://www.excelbanter.com/excel-discussion-misc-queries/100735-unhidding-sheets.html)

starguy

Unhidding sheets
 

I have hide my sheets by following procedure.
Control toolbox tool bar properties visible (very hidden)

how can I unhide these sheets.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563979


VBA Noob

Unhidding sheets
 

Press Alt + F11 to go to Visual Basic screen.

Select the hidden sheet and press F4. This will display the property
box so you can change the sheet properties

http://www.j-walk.com/ss/excel/usertips/tip036.htm

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563979


Ardus Petus

Unhidding sheets
 
Same way around:
Control toolbox tool bar properties visible (visible)

HTH
--
AP

"starguy" a écrit dans
le message de news: ...

I have hide my sheets by following procedure.
Control toolbox tool bar properties visible (very hidden)

how can I unhide these sheets.


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563979




starguy

Unhidding sheets
 

thanks it solved my problem.

VBA Noob Wrote:
Press Alt + F11 to go to Visual Basic screen.

Select the hidden sheet and press F4. This will display the property
box so you can change the sheet properties

http://www.j-walk.com/ss/excel/usertips/tip036.htm

VBA Noob



--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563979



All times are GMT +1. The time now is 02:20 AM.

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