Pdf only certain ws as individual pdf files?

[Viperuk]

Hi all.

I am struggling to select 10 ws in a wb of around 25 ws and print them to individual pdf files. I would also like each to be renamed the ws name.

I can pdf each ws in the wb to pdf and re name but this isn't what I need.

I have tried to hide those worksheets which are not needed to be pdf'd but I seem to get an error? I think this is because the buttons which run the code are on a sheet which then becomes hidden. I cannot put the buttons on a sheet I want to pdf.

There must be an easy way to do this but I am struggling.

Any help would be appreciated.

Thanks

 

[BQardi]

Maybe check each ws name and "ignore" those that you specify ("Sheet1", "Sheet2", etc.):

Dim ws As Worksheet
For Each ws In Worksheets
    If Not ws.Name = "Sheet1" And Not ws.Name = "Sheet2" Then
        'ws to pdf code here
    End If
Next ws

 

[Viperuk]

Thank you.

I will try that.

Appreciated.