open worksheets

  1. K

    How to...open a workbook and cut data selected by column title

    Hi folks, I work in health analysis and i am working on analysis of waiting lists. I have built an analysis sheet where the relevant data can be pasted, what i now need to do is to work out an easy way to strip the data from another sheet. This is essential as the tool will be make...
  2. G

    Simple Code to open multiple hidden worksheets

    Hello, Very new to VBA. Working off a code that hides worksheets until a password given to open them. I want to modify this so that it will open more than one sheet... What I have: Option Compare Text Const pWord2 = "XXX" Sub showsheets2() Select Case InputBox("Enter Raw Data...

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