Save XLSM as XLSX error Hi

The following code works fine until I want it to save as a XLSX file. No matter what I do its shows an extension error.

Any Ideas ?


Code:
---------
Private Sub CommandButton1_Click()
https://www.excelforum.com/sho....wthread.php?t=142455

Refreshing a pivot table Hi there

I just wondered if there was a way of refreshing 3 pivots tables in one go WITHOUT

1. Clicking each table separately and clicking Refresh
2. setting up a macro ( don?t want to save file as macro enabled)

Thanks in advance.

Jacc14
https://www.excelforum.com/sho....wthread.php?t=142455

Hello and thanks Hi folks,
I stumbled on your forum and found a lot of great tips already.
Thank you!
https://www.excelforum.com/sho....wthread.php?t=142455

Conditional formatting a cell with a Formula I am trying to set up conditional formatting for a cell only if the cell itself has a value.

Unfortunately the cell I am trying to format has a formula so it seems to be always coming out a "true" in my conditional format formula.

Is there a way to have the cell colored only if there is an...
https://www.excelforum.com/sho....wthread.php?t=142455

Code to transpose print areas to one sheet Hi. I need to modify the code in the attached sample file so that the two print areas are transposed from horizontal to vertical so that they both print on one page.

The file contains 3 sheets: Source - the original layout, Required Results - how I want the printout to look, and Target - not...
https://www.excelforum.com/sho....wthread.php?t=142456