For Each ws In ThisWorkbook.Worksheets question

[thewaksta]

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

 

[przemek]

HI Neil,

I've added dots to qualify references, but then accually got a error message "Invalid or unquailified reference". Not sure if this is caused because of the fact that code isn't in active workbook.

Any suggestions.

Thanks