Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Newbie question, I think I have some macros in my workbook that are activated by <ctrl<shiftA, <ctrl<shiftB, <ctrl<shiftC, etc. My prob is that they work on EVERY sheet, but i'd like them to work only on certain designated sheets. Any ideas how to go about this? Merci Giselle |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Giselle, you could check for the sheet name like this,
Sub test() If ActiveSheet.Name = "Sheet2" Then 'Your Code here Else Exit Sub End If End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Giselle" wrote in message ... Hi Newbie question, I think I have some macros in my workbook that are activated by <ctrl<shiftA, <ctrl<shiftB, <ctrl<shiftC, etc. My prob is that they work on EVERY sheet, but i'd like them to work only on certain designated sheets. Any ideas how to go about this? Merci Giselle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |