Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account