Hello...
I wish to have a command button that can hide/unhide with various safe file option based on drop down list value in G6. Here is a table:


C2 : Open (hide Command Button)
C3 : In Progress (unhide Command Button and save file only)
C4 : Cancel (unhide Command Button and save & close file immediately)
C5 : Close (unhide Command Button and save & close file immediately)
G6 : Drop Down List box


Appreciates the helps. TQ.