DoCmd.ShowToolbar "Ribbon", acToolbarYes

[sumdumgai]

Is there a way that I can give a single user the ability to change the 'ShowToolBar' command from yes to no and vice versa on a VBA 'Locked for Viewing' database without sharing the VBA project password?


I'd rather not create a table, or dynamically modify the VBA code. Is there a load Access switch that I can use, for example?



Thanks.

 

[isladogs]

See my example application: https://www.access-programmers.co.uk/forums/showthread.php?t=293584

FYI VBA project passwords are EASILY disabled
Much better to convert to ACCDE and encrypt the whole database with a strong password