Macro to remove/change some fields and save the file.

[OpOrange]

Hello all. I am new to this forum but you all have helped me do this so far but I can't find what I am looking for, so I going to try to explain the best I can.

I am trying to simplify when I write a work order for where I work. I have ready created a SAVE AS button to save the file as a specific name and in a specific folder.
But now I want to know if there is a way to completely remove everything circled in red below, and do like a "paste special" and "values" for everything in blue. Because the person who prints the work orders does not like what I am doing to make my life easier. So basically I want her to not know anything about it.

Untitled.jpg

Hope someone can help me.

And here is what I wrote for my SAVE AS BUTTON.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi, and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Since you're new here I'll change it for you on this occasion but please note for the future.


(

[OpOrange]

I apologize. Thank you for your help.

[Richard Buttrey]

Hi,

Untested but try...

Please Login or Register  to view this content.

[OpOrange]

That worked, I had to move the clear to the bottom since it was clearing the data before pasting it.

The one thing it didn't get rid of was my button. Any way to make that happen?

[OpOrange]

Also what would the code me to make cells; A3:A15 have no color fill?

[Richard Buttrey]

Also what would the code me to make cells; A3:A15 have no color fill?

Hi,

Please Login or Register  to view this content.

..and the button..

Please Login or Register  to view this content.

Change the sheet CODE name and 'button' name as necessary

[OpOrange]

Please Login or Register  to view this content.

How would I have this to make it be a .xlsx file rather than a .xlsm?

[Richard Buttrey]

How would I have this to make it be a .xlsx file rather than a .xlsm?

You can't. By definition if you have macros in a file then it has to be a .xlsm file. That's what the last 'm' means.

What's the difficulty with saving it as .xlsm?

[OpOrange]

No difficultly. I just wondered if it could me done. Thought it would be easier to hide what I am doing from the lady that prints the work orders.
THANKS FOR ALL YOUR HELP WITH THIS!!!

[Richard Buttrey]

Hi,

If you want to confuse her even more then you could save it as a .xlsb file.

But thinking about this a bit more and since you don't want the lady to even know it's got a macro, you could save it as a .xlsx file. I was just sticking with your original file naming coded.

Just change the file name to include .xlsx in place of .xlsm and format the FileFormat bit of your code to

Please Login or Register  to view this content.

You might also like to consider saving it as a pdf file then the lady in question couldn't use it as an Excel file.

[OpOrange]

Thank you! This has solved my issue!