Home Creators Posts Import Register Favorites Logout

Downloads

Content

In this week’s Feature, Fix, or Focus, we take last week’s Share & Sync Add-in training.

Here's the list of updates I made for this training:· Toolbar Updates added by Randy Austin

      Logged  In / Previous Logged In User

      Logged In Date & Time

      Logged in Status

· Admin user protections added by Randy Austin

      Prevent Admin user Role or Name change

      Prevent admin user delete

· Add-in Workbook Protections added by Randy Austin

      Removed Add-in from Visible Workbooks to prevent removal or modification

· Shared Settings added by Randy Austin

      Sync Frequency

      New User Email Macros & Settings

      New Shared Workbook Macros & Settings

· Logout On Close of all workbooks added by Randy Austin

· Show Logged In As (then login date/time) added by Randy Austin

· Updated SUMPRODUCT formula with Addin name variable added by Randy Austin

· Sync Frequency in Settings form & Updated macro added by Randy Austin

· Login Reminder On Workbook Open added by Randy Austin

· Add list of users per workbook added by Randy Austin

· Email Users File added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

jwuj97f

Thanks for the wonderful updates - question how to resolve the message "Ribbon is not initialized?"

Excel For Freelancers

You can comment out that line of code. It is not necessary. I hope this helps and thanks so much.

jwuj97f

cool, will do. Thanks

Mayer Gottlieb

Hi randy, How can i assign the "sync Workbook" to a button on my sheet?

Excel For Freelancers

HI Mayer, thanks for your message. This this is an addin, you would not want to add it on your sheet, however you would want to add the button on the custom toolbar so that it is available for every workbook. I show you how to add buttons to a custom ribbon toolbar in this video https://youtu.be/woDVi79vD3A I hope this helps and thanks so much.

Ly Sieu Minh

Hi Randy, I need to integrate some lesson learned from your youtube into one workbook in custom ribbon. I knew you have one lesson to teach that, but I can not find it. Please help to send me that youtube link Thanks