worksheet activate

  1. R

    Button to open next worksheet doesn't work.

    I had the code below on a button, but when I press the button nothing happens, I am on sheet 1 of 31 when I press the buton. Any ideas from anyone? Sub NextSheet() Set sh = ActiveSheet On Error Resume Next Do While sh.Next.Visible <> xlSheetVisible...
  2. C

    Userform and ComboBox Question

    Hi All, I've searched around a few threads and picked bits of code to end up with the code below on my Userform to transfer data. I'm sure it's very ugly but works at the moment. I need help with two things though. Firstly when the Userform opens I can't click on the worksheet behind it and say...
  3. E

    Worksheet activate not happening when workbook first opens

    Hi, I have a workbook where the sheets are all protected and I want to stop users scrolling up or across beyond the limits of the input areas. I have used the following code (or variations of)... Private Sub Worksheet_Activate() Me.ScrollArea = "A1:G32" End Sub This works fine except that...
  4. C

    Copy From Other Sheet, Paste to This Sheet on Activate

    I have a Personnel Worksheet that is automatically sorted by Hire Date when the worksheet tab ("Hire Date") is clicked. This works well. I am trying to display the same data on another sheet, sorted by last name when the worksheet tab ("Last Name") is clicked. Many other worksheets will...

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