PDA

View Full Version : Selecting sheets in add-in



shankar
04-17-2009, 03:31 AM
I am working on a VBA project which I would be converting into an add-in later. I read that any sheet in ThisWorkbook cannot be activated in an add-in. Does this mean that I cannot use statements like ThisWorkbook.Sheets("Sheet1").Select? Does selecting a sheet require it to also be activated?

Selecting the sheet means I can avoid With/End With and periods in front of Range or Cells (a minor inconvenience). But if selecting wouldn't work later with an add-in, I guess I would code it in the above manner. Thanks.

Shankar

Bob Phillips
04-17-2009, 03:51 AM
Whether you can or you can't select a sheet, you shouldn't. Go with With ... End With