Thank you Hui! This is absolutely perfect! However, there is only 1 change I would need. The default is to check all worksheets. Is there anyway to make the default unchecked for all worksheets? Again, I'm sure it's an easy fix, but I'm still too new to VBA for this one.
I posted this before but still have not received a solution. I am a VBA beginner and I'm not sure how to proceed. I have attempted to create a macro to "PrintSelected" sheets from over 200+ Active worksheets. I had a Macro to print based on checkboxes, but it wouldn't show all active worksheets...
Vijay, Thank you for the suggestion. However, I'm still learning Macros and I cannot figure out how make the changes to use a List Control instead of CheckBoxes.
I am using the following Macro to allow users to select which worksheets they would like to print. The problem is I have 200 worksheets in my file and the list is too long to appear in the menu. Is there a way to make it so the user can scroll through the full list?
Option Explicit
Sub...
I am trying to create a macro to print worksheets from a list. For example, on my worksheet "3Print" I have a list of the tabs that I would like to print in cells G60:G130. I have 6 other lists that I need to create seperate Macros for, but if I can get help with just one, I'm sure I can change...