I recorded a macro in Sheet 1 and I have about 3 Sheets in the workbook. But I notice that I have to open Worksheet 1 for the macro to run else I get error. What can I do to make sure that once the workbook is open regardless of which sheet am in, my macro chosen will still run and execute properly. All help appreciated! Thanks much.

Hi

Keep in mind: Recording a macro is a feature very helpful to get an idea what is required or to figure out methods, properties, ... whatsoever. But the recording also records all your selections you did, and at least that part you have to transform to another syntax.

Now I don't know your macro, but whatever you want the macro to perform you have to address explicity where it should be performed. The right thing would be, to enter a formula in Sheet2:
Though it's not necessary to address "Thisworkbook" if your "Sheet2" is within the active workbook. The same applies to the address "Sheets("Sheet2"), if the Range is within the active sheet.
So probably by now you know what to change in your macro. If not, just post your code, and I will show it on your example.

Thanks Whatsup. I am a bit confused with the entering a formula in sheet 2 and putting the code in. Like I said If sheet 1 is not open where the saved macro is (which I recorded), I get error - I am looking for a way to make the macro run regardless of which sheet is open. Your assistance in getting this right will be appreciated. Below is my sample code, kindly modify to make it clearer. Thanks

Sub Trials()
'
' Trials Macro
'

'
Selection.AutoFilter
ActiveSheet.ListObjects("Table_Query_from_MS_Acces s_Database").Range. _
AutoFilter Field:=6, Criteria1:="Owner"
ActiveSheet.ListObjects("Table_Query_from_MS_Acces s_Database").Range. _
AutoFilter Field:=13, Criteria1:="WA"
Cells.Select
Range("Table_Query_from_MS_Access_Database[[#Headers],[First Name]]").Activate
Selection.Copy
Sheets("Result").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
End Sub

QueryTables - hm I saw your other thread afterwards...

Anyway, try if this works:
Basically it's important that you can't use ActiveSheet in a macro if you start the macro from another sheet - obvious isn't it? Therefore you have to refer explicitly to the sheets name, or as above the sheets position in your workbook.

Unless, of course, your code activates the sheet concerned (e.g. ThisWorkBook.Sheets("MySheet").Activate). But even that requires the sheet to be named for activation. Not a recommended way to program - it's both inefficient and error-prone.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Whatsup - your bottom explanation spoke volume. I am just picking up with Macro and programming and thanks for Helping! I just named the sheet and referenced that, which helped.

Macropod - I appreciate your input.