How to unhide all columns with vba

[vmon]

Is there are command or snipit of code someone could share to unhide all columns in a datasheet subform when a form is opened?

Thanks,
vmon

 

[dcobau]

why do you want to hide them in the first place?

 

[boblarson]

DoCmd.RunCommand acCmdUnhideColumns

 

[Snowflake68]

This code pops up the Unhide popup window. DoCmd.RunCommand acCmdUnhideColumns

BUT can someone tell me what code just sets all columns to visible as I dont want the pop up.

 

[JHB]

The link shows how to hide a column, you can use the same code to unhide a column by setting the Properties("ColumnHidden") = False.
https://msdn.microsoft.com/en-us/li...v=office.11).aspx?f=255&MSPPError=-2147217396