workbook.printpreview function

[lezawang]

Hi
I wanted to know the synatx of PrinPreview function which is part of Workbook object.
So I went to object viewer and found out that excel define this function as

Sub PrintPreview([EnableChanges])

I have 2 questions please

1) Why sub? the icon infront of the function is green box which means it is function not sub
2) Why the ( ) and why there is an argument (EnableChanges) passed? I can call this function like this

Thisworkbook.printpreview

so I did not have to pass anything? then why the syntax is showing it takes an argument. Thank you so much

 

[=ODIN=]

No idea about the sub thing, but it looks like the "EnableChanges" argument is optional and is set to True by default I think. The below link is Microsoft's reference to it.


https://docs.microsoft.com/en-us/office/vba/api/excel.sheets.printpreview

 

[Jaafar Tribak]

Hi
I wanted to know the synatx of PrinPreview function which is part of Workbook object.
So I went to object viewer and found out that excel define this function as

Sub PrintPreview([EnableChanges])

I have 2 questions please

1) Why sub? the icon infront of the function is green box which means it is function not sub
2) Why the ( ) and why there is an argument (EnableChanges) passed? I can call this function like this

Thisworkbook.printpreview

so I did not have to pass anything? then why the syntax is showing it takes an argument. Thank you so much

1 - The green icon means it is a Method .. A Method can be a a sub or a function
2- ([EnableChanges]) is between brackets . This means it is an Optional Argument which you can ignore ... In the case of the PrintPreview Method, if you ignore the argument it defaults to TRUE ie:Call PrintPreview(True) is the same as Call PrintPreview().