Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve
 
Posts: n/a
Default 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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
Steve
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
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
find links to another workbook Patricia Excel Discussion (Misc queries) 1 January 21st 05 09:33 PM
copy COLUMN from 1 worksheet to another (in a different workbook) DavidB Excel Discussion (Misc queries) 3 January 15th 05 02:47 PM
copy a workbook from other workbook with lot of sheets wit... Vai Excel Discussion (Misc queries) 1 January 3rd 05 10:27 PM
Creating a subbook from a workbook. Chaplain Doug Excel Discussion (Misc queries) 0 December 19th 04 11:31 PM
Problem with shared workbook (history sheet) ACH Excel Worksheet Functions 2 December 9th 04 08:39 PM


All times are GMT +1. The time now is 08:55 PM.

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

About Us

"It's about Microsoft Excel"