Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I cant hide a workbook
Happy Holidays to all!
I had my personal workbook hidden. I had to unhide to edit a maro, now I cant rehide. I have closed Excel and reopend and I still cannot hide it. Any ideas? Thanks Steve |
#2
|
|||
|
|||
Hi Steve
with personal.xls in focus choose window / hide Cheers JulieD "Steve" wrote in message ... Happy Holidays to all! I had my personal workbook hidden. I had to unhide to edit a maro, now I cant rehide. I have closed Excel and reopend and I still cannot hide it. Any ideas? Thanks Steve |
#3
|
|||
|
|||
HI Julie
The only option that is there is to unhide another book that is hidden. It is like that for all open books---None can be hidden. Thanks for the response "JulieD" wrote: Hi Steve with personal.xls in focus choose window / hide Cheers JulieD "Steve" wrote in message ... Happy Holidays to all! I had my personal workbook hidden. I had to unhide to edit a maro, now I cant rehide. I have closed Excel and reopend and I still cannot hide it. Any ideas? Thanks Steve |
#4
|
|||
|
|||
What happens when you try it?
Are you sure Personal.xls is actually opening? And you don't need to unhide personal.xls to edit its code. Just hit alt-f11 to get to the VBE then ctrl-r to view the project window find personal.xls and edit to your heart's content. Remember to save it (while in the VBE) or when you close excel. Steve wrote: HI Julie The only option that is there is to unhide another book that is hidden. It is like that for all open books---None can be hidden. Thanks for the response "JulieD" wrote: Hi Steve with personal.xls in focus choose window / hide Cheers JulieD "Steve" wrote in message ... Happy Holidays to all! I had my personal workbook hidden. I had to unhide to edit a maro, now I cant rehide. I have closed Excel and reopend and I still cannot hide it. Any ideas? Thanks Steve -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find links to another workbook | Excel Discussion (Misc queries) | |||
copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
Creating a subbook from a workbook. | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |