Hi,
This may be low ranking amongst the worlds problems but for the life of me cannot sort this out.
I have a spreadsheet (Excel 2010) with some vb code that saves some pages in the spreadsheet as a pdf.
" .ExportAsFixedFormat _
Type:=xlTypePDF,"
When I click the button, everything that should happen does except for the fact that all the commandbuttons in the spreadsheet shift to the left and resize to a smaller size.
Any help appreciated
Cheers
Jeff
This may be low ranking amongst the worlds problems but for the life of me cannot sort this out.
I have a spreadsheet (Excel 2010) with some vb code that saves some pages in the spreadsheet as a pdf.
" .ExportAsFixedFormat _
Type:=xlTypePDF,"
When I click the button, everything that should happen does except for the fact that all the commandbuttons in the spreadsheet shift to the left and resize to a smaller size.
Any help appreciated
Cheers
Jeff