Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

How display ONLY "Close Print Preview" and "Print" on the ribbon

I have the following code which hides the ribbon from displaying:

'Code to hide ribbon if user is security level 2 or higher...
    If DLookup("[SecurityLevel]", "LOCALtblCurrentUser") > 1 Then
         DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End If

Open in new window

But what I really want to do is allow the user to "Close Print Preview" and "Print" from the ribbon when a report is previewed, nothing else.  Can this be done?
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial