Hi I am trying to change this code so that it only saves the print area of the active sheet, is anyone able to help. I think it's almost their just needs a slight change, as I'm sure you can tell, I don't know much about VBA
Please Login or Register to view this content.
Are you wanting to save as pdf as per this link here
then you must specify the print area...
Please Login or Register to view this content.
Last edited by sintek; 03-25-2020 at 04:58 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi thanks for the reply,
No I wanted to save it as a macro-enabled worksheet/workbook, on the other pages I have confidential information that cannot be included
Don't think I understand...Please elaborate...
I have 5 sheets in my workbook, 4 of the sheets contain information such as pricing & customer names, addresses ect which I don't want to be included in the new excel document I am creating...
One of the sheets, "sheet 1" I would like to save into a public folder by clicking a button. ("C:\Users\" & username & "\Dropbox\QUOTES")
Basically, what I am trying to do is save the print area of one "sheet 1", have the file name as "K3" & the file location as "C:\Users\" & username & "\Dropbox\QUOTES" & the format to be macro enabled workbook so that it can be edited by other users.
It's quite important that they can't see the other four pages. Sorry if I haven't explained myself very well.
So why not just hide these sheets...xlsheetVeryHidden or delete the sheets prior to save...
What macros does the workbook contain pertaining to those sheets only that these users need to access
Last edited by sintek; 03-25-2020 at 05:42 AM.
Deleting them could work. I'm guessing this isn't easy to do?
I also thought about VBA to copy & pasta a .PasteSpecial for all followed by a .PasteSpecial xlValues, I thought this would be more difficult though.
With regards to deleting the other sheets, is this possible through VBA, whilst at the same time saving as a new workbook with filename as K3 & in a set folder?
Please Login or Register to view this content.
Are there macros on sheet1, if not what is the point of saving as .xlsm ?????
Sorry I don't know why I didn't think of this before, once the other sheets are deleted, on sheet 1 it comes up with #REF because they were linked to the deleted pages. Are you able to help with copy & pasting format then values then saving as K3 in the folder?
Say to copy the activesheet range A1:H28 to a new worksheet, paste as format & column spacing, followed by values. Then save as K3 from the original workbook? I don't know if this would work?
chris888...Put us out of our misery and upload a sample file...
Also answer some of the questions...Why macro-enabled...what code pertains to the sheets etc etc...
What functions does the users need...
As you have formulas linked to the other sheets...You need these sheets in the file...
If you only want formulas then why need to save as macro enabled
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks