I know it's possible and have tried searching the FORUM, but couldn't find the exact answer. I have built an Excel model and would like the Workbook to OPEN without the Ribbon, Formula Bar, Headings, and Gridlines displaying BUT only for this workbook, without effecting other workbook that may be open or will be opened later.
I know it's an easy VBA code, but am unsure exactly how to do it. I'm working with Excel for Office 365 (32 bit).
PS I'm not a VBA expect
Thanks
Hello SimonCampbell,
You may place this Code in the VBE ThisWorkbook_Event;
See the attached sample Workbook
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Excellent.. thank you... but this also hides the Quick Access Toolbar... I need end users to be able to save changes, but I suppose I could include a Button with macro to "Save Changes".. any comments ??
Simon
Hello SimonCampbell,
Thank you for the feedback.
Would it then be o.k. if we make the ribbon available for the users, should they want to save other changes as well?I need end-users to be able to save changes...
Last edited by Winon; 11-02-2019 at 12:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks