how to embed a sheet and call it for a command

[UMAKEMESIK]

I have a command I would like to run on a work sheet.

With a macro button I would like to call on sheet 2 for the command but my syntax is incorrect.

Any help would be appreciated.

here is my code.

Application.ScreenUpdating = False
    
    Worksheet.Open Sheets(Sheet2)
       
    Range("A1").Select
    Selection.Copy
    ActiveWorkbook.Close
    Range("AB3").Select
      ActiveSheet.Unprotect "dod"
    ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
        DisplayAsIcon:=False
    ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
        True
    Application.ScreenUpdating = True

mY worksheet open line is getting the error.

thanks

 

[hiker95]

UMAKEMESIK,


If the worksheet name is Sheet2, try:

Worksheets("Sheet2").Activate

If the worksheet is the second worksheet (moving left to right) try:

Worksheets(2).Activate

 

[UMAKEMESIK]

Thanks for taking the time.

I think it's doing exactly what it is supposed to. When I click on the macro button that calls out that command it closes the first sheet and then closes everything.

Here is what I was thinking of doing. Everything below the worksheet acitivate line works in another scenario. I have a separate worksheet called numberlog and when i click on the button on worksheet 1 it calls to the number log worksheet. The numberlog worksheet generates a number and then that number gets pasted back onto worksheet 1.

This is how i generate a sequential numbering system to create non-repeating workorder numbers.

I am trying to embed the Numberlog worksheet into worksheet 1 so the user does not have to be connected to the network and can generate their own series of workorder numbers when they are working offline.

Any help would be appreciated.

 

[hiker95]

UMAKEMESIK,

I am not following what you are trying to do.

Please click on the Post Reply button, then enter just the word BUMP, and then click on the Submit Reply button, and someone else will assist you.

 

[UMAKEMESIK]

bump