PageSetup has no effect

Hi everyone,

I've recorded my changes into a macro so I hoped I'd be off the hook but it doesn't seem to have any effect. After executing the marcro, the workbook is still in portrait mode instead of landscape, and the margins are unaltered.

The only thing I can think of at the moment, is that the macro code resides in personal.xls. Maybe that prevents the macro from altering things in other workbooks? It has to be there so that the marco is accessible to every workbook.

Below is the Excel generated code

cheers,

Jeroen

Please Login or Register  to view this content.

Your code works on the Activesheet so provided that the sheet you are changing is actually active then the code should work on it.

Can I somehow display the active sheet so I can make sure Excel is using the correct one and if not, change it to the correct one?

Edit:

I've got a lead. I executed:

Please Login or Register  to view this content.

And it returned that personal.xls was the active workbook and page1 the active sheet. How do I change this do the worksheet I have opened (= the worksheet that calls the macro).

Thisworkbook refers the workbook with the code being executed.

Try Activeworkbook instead.

Please Login or Register  to view this content.

That indeed outputs the correct data.

I suppose I will have to be able to change the ActiveSheet now

My warmest thanks for helping me out (again)


Edit: for future fellow Excel beginners:

Please Login or Register  to view this content.