Hi,
I'm very new to VBA and have a problem which I'm sure must be very simple to solve but I have no idea how to go about this.
I have a workbook with three permanent worksheets (Summary, Employees, Project Rules). I want to add new worksheets to this workbook and format them without touching the permanent sheets. I would like to tell VBA to format every worksheet that is not named Summary, Employees or Project Rules (or alternatively all worksheets except for Sheet1, Sheet2 or Sheet3). How can I do this?
Thanks
thewaksta
I'm very new to VBA and have a problem which I'm sure must be very simple to solve but I have no idea how to go about this.
I have a workbook with three permanent worksheets (Summary, Employees, Project Rules). I want to add new worksheets to this workbook and format them without touching the permanent sheets. I would like to tell VBA to format every worksheet that is not named Summary, Employees or Project Rules (or alternatively all worksheets except for Sheet1, Sheet2 or Sheet3). How can I do this?
Thanks
thewaksta