I've written a spreadsheet for others to use, protected it (except for cells where data input is required). Almost like an App for sales people to prepare quotes. I want it to appear fullscreen only with formula bars and headings permanently hidden so feels the experience for the User is similar to an App.
How on earth do I do it?
Hello IAN M and welcome to the forum !
Open your spreadsheet and press alt+F11
in the left hand side locate your workbook name then locate below Thisworkbook and double click the same a window will open then copy paste below
and save workbook as macro enabled book
Open the attachment press Alt+F11
Please Login or Register to view this content.
left hand side locate VBA Project(Protect.xlsm) below find thisworkbook double click and you will see the code
to copy same in your workbook
left hand side locate VBA Project(your workbook name ) below find thisworkbook double click and copy paste the same code
save your workbook as macro enabled book
click " * " add reputation icon if above helps you
Last edited by hemesh; 02-09-2014 at 06:52 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thanks for assistance!! I followed instruction but got message "Compile Error: Ambiguous name detected: Workbook_BeforeClose
Spreadsheet is already macro enabled with
as well asPlease Login or Register to view this content.
Perhaps this is confusing the issue?Please Login or Register to view this content.
Thanks/Dankie Winon
Last edited by Ian M; 02-09-2014 at 07:39 AM. Reason: Adding CODE tags, thanks and sample
Hello Ian M,
Welcome to the Forum.
Moderation requests removed, as OP has reponded to same.
Last edited by Winon; 02-09-2014 at 08:00 AM.
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] .
Ian
that means you have two subroutines named Workbook_beforeclose
Copy the code lines from Hemesh's Workbook_before close and incorporate them into the already existing routine
Elegant Simplicity............. Not Always
Hello find the attached ! There is no problem here ! After adding your code ! As per the litch you had two WBK_Open subs
Didn't See your file at first !
Last edited by hemesh; 02-09-2014 at 07:49 AM.
Thanks - got it!
Hello Ian M,
Dankie vir die samewerking.
I think AndyLitch, and hemesh managed to clear things up for you, by spotting where you went wrong with your VBA.
If your issue has been sorted out, then please mark your thread as Solved, or do you have some other issues remaining?
Regards
Hunting . . . how do I mark as solved?
. . . . . . read the rules!! (Proving I am a normal male - read the rules only after trying first!)
Last edited by Ian M; 02-09-2014 at 08:32 AM.
LOL!
Typical. Applies to me as well!. . . read the rules!! (Proving I am a normal male - read the rules only after trying first!)
Thank you for catching up so fast.
Groete.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks