Hi Paul,
I found macros to export all the sheets to PDF, but I need to select only
the specified sheets into PDF. If you have any references please share. It
will be very useful for me to make this task bit easier.
Thanks,
Saravanan R
On 13-Aug-2015 7:44 pm, "Paul Schreiner" wrote:
> Are you fa
THANK YOU VERY MUCH FOR YOUR HELP
On Monday, 17 August 2015 16:43:38 UTC+5, Paul Schreiner wrote:
>
> In the autofilter panel,
> you are selecting cells that begin with "M".
> In the next box,
> choose cells that do NOT begin with "MN"
> [image: Inline image]
>
> *Paul*
>
Are you saying that you want the macro to repeat for all sheets?
If so, you need to set up a loop to process all sheets.
Using your macro, you can create a separate macro like:
Sub Process_All()
Dim Sht for each Sht in Sheets if ((sht.name <> "Summary A") _ and
(sht.name <> "Summary B") _
In the autofilter panel,you are selecting cells that begin with "M".In the next
box,choose cells that do NOT begin with "MN"
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you c
Please notice the Forum Rules:3) Don't post questions regarding breaking or
bypassing any security measure.
If you are the owner of the application, there are places to go to get it
unlocked.Simply Google something like:
excel vba password recovery
I found 357,000 hits...
Paul---
Hello,
if you talk about cells lock, try below code:
"
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 A
Hi sham,
Please help me with these workbook. I have tried the steps below but i
couldn't break the password.
Awaiting yours
*Idris*
On Saturday, February 20, 2010 at 6:27:18 PM UTC+1, SHAM wrote:
>
> To crack the password of an VBA Macro / coding first download an HEX
> Editor
>
> its availabl
Hello Experts,
I have this code which works fine except that I am not able to repeat in
on all sheets. When I edit the code it doesn’t perform the same routine.
I have multiple sheets in a workbook and I want this code to run on all
the sheets except the first 3 (named – Summary A, Summary
