worksheets()

  1. C

    Correct use of Worksheets statement in VBA

    I have a function where I am seeking to look across from a worksheet in one workbook to a worksheet in another workbook. I have created a name reference across to the other sheet, the name is Subsidiary_Names_Sheet. I then use that name in the call to my function within the CELL function...
  2. L

    Using Excel Shared Workbook with VBA code applied to 12 Worksheets

    I have a shared workbook which has 12 worksheets and each Worksheet has to following VBA code to lock cells after data entry: Private Sub Worksheet_Change(ByVal Target As Range) Dim cl As Range ActiveSheet.Unprotect...
    • Lobo1943
    • Thread
    • code locking cells sharing workbook vba worksheets()
    • Replies: 0
    • Forum: Excel Questions
  3. J

    Is there a collection that holds all sheets: work- chart- dialog-

    Is there a collection that holds all sheets: work- chart- dialog- ? What would be the DIM datatype of a member? (none of the intellitype options seem to fit) Also, when I add the use of the dialog() collection VBA says it can't recognize the whole sub() Tester I am using Sub...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top