none
want to hide a workbook RRS feed

  • Question

  • Good afternoon all.

    I know I have a macro to do this somewhere, but I'm not able to find it right now.

    I have a workbook which opens each time I open Excel. I'm fine with the workbook being opened (I have macros in it which I use throughout the day), but I really want it hidden--- permanently, UNLESS I go to unhide it, myself.

    I have recorded a macro to hide the workbook, but as with most macros, I want it to automatically activate, so I don't even have to see the workbook. How would I accomplish this?

    TYIA.

    Friday, May 20, 2016 9:05 PM

Answers

All replies

    • Marked as answer by SteveDB1 Friday, May 20, 2016 9:31 PM
    Friday, May 20, 2016 9:31 PM
  • You don't need a macro.

    • Start Excel.
    • Macro sure the workbook this is about is the active workbook.
    • Activate the View tab of the ribbon and click Hide in the Window group.
    • Quit Excel.
    • Excel will ask whether you want to save changes to the workbook.
    • Answer Yes. This is essential!

    Next time you start Excel, the workbook will be hidden.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by SteveDB1 Friday, June 3, 2016 8:52 PM
    Friday, May 20, 2016 9:35 PM
  • Hi SteveDB1,

    its good to hear from you that you have found the solution of your issue by yourself.

    Thank you to share the solution with our community so that if some other community member have same issue like you can also get solution from your post.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, May 23, 2016 2:11 AM
    Moderator