Code runs on entire workbook...need it to only run on one worksheet

Hey there,

I am new to writing vba code and came across this problem. Seems pretty simple but I can't seem to get it to work. I am looking for the below code to work only on sheet1 of the workbook. Please help??

Please Login or Register  to view this content.

jrobertson,

Welcome to the forum. Unfortunately your post does not conform to rule #3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

To edit your previous submission click 'Edit Post' below post #1. Highlight your code and press the # in the toolbar.

Please Login or Register  to view this content.

Hi,

You need to learn about VBA code behind a worksheet vs behind a MODULE. If it is behind a single worksheet it can only function on that worksheet. It seems you have this code behind a module so it can work on any worksheet.

Look at http://www.contextures.com/xlvba01.html for more of what I'm thinking you need to learn/understand.

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



(I have added them for you today. Please read all forum rules and comply in the future.)

Hi jrobertson2403. First, it isn't necessary to quote an entire post just to respond that it wasn't successful. It adds clutter to the thread.

Can you clarify your question? That is, you said that you want this code to run only on one specific worksheet. The code provided by Solus Rankin does indeed run only on one Sheet1, but I'm not convinced that's what you really meant. Do you mean "run this code only when Sheet1 is being printed but not if any other sheet is being printed"?

The Workbook_BeforePrint detects when any print event occurs anywhere in the workbook, but it cannot detect a print event for any specific worksheet. There may be some way to do it but I couldn't find it. The alternative would be to create a macro specifically to print Sheet1 and then also run this code, but then you (or the user) would have to use that macro rather than just hitting Print.