I want to thank you, Randy. I have been building our very own Mechanic Shop system off of your videos and I have learned so much. You make it simple to understand. Before I found you, I had no idea that vba was even a thing. Our shop is very small and you have everything we need! Keep up the great work!
Hi and thanks so much. Yes for sure. Multiple users can work on the desktop version at one time. To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html
Hello Randy, Thank you for responding to my other comment. After getting my program set up, I did realize I do not know how to get the workbook to not close if the user is not logged out. VBA suggestions? Thanks again!
Hi and thanks very much Amanda. In the workbook events, you have a 'BeforeClose' event. In this event, you can write a small line of code. Something like Private Sub Workbook_BeforeClose(Cancel As Boolean) ' Reference the worksheet, replace "SecSht" with your actual sheet name Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("SecSht") ' Update with the actual sheet name if different ' Check the condition in cell B2 If ws.Range("B2").Value = "Logged In" Then MsgBox "Please make sure to log out before closing this workbook", vbExclamation Cancel = True ' Cancel the close operation End If End Sub I will add this to the update on Patreon for this Monday www.patreon.com/ExcelForFreelancers
Thanks Amanda. I have also added this into the update, plus a ton more including user roles, prevent copy and paste, save as, drag and drop and a whole lot more for the update on Patreon in just a few days www.patreon.com/ExcelForFreelancers Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy❤. Love your videos❤🎉🎉. Can you please please 🙏 add a hospital manager series like the school manager series with many features please ❤.thank you love from Tanzania, east Africa.
Hi and thanks very much. I would love to, but the large, multi-part videos get very low views, so I have to keep everything into a single video. I have a Clinic Manager, but not a Hospital Manager. Perhaps you can share some ideas and I will try to get the minimum # of features into a single video? What would you like to see? Feel free to email me as well Randy@ExcelForFreelancers.com Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy. Thanks a lot for the add-in. I watched the video and tried it. But it seems like everyone can edit the users' rights. I think only the admin should be able to do that. Or maybe I missed something?
Hi and thanks very much. On the Patreon Update I will be adding an 'Admin' role in which only those with Admin rights will be able to make edits. I will be releasing it this Monday here www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Thank you, Randy. Just a few questions I want to find out. 1. If I did have a sheet in my workbook and I delete it, it still show under my username, how to get rid of it. @. I I add a user and I gave him the workbook, will it work on his computer so he must input userid and password, as I do not give them the xlam file .
Thank you Hendrik. If you delete a sheet, the macro can run through all the sheets, check for deleted sheets and then delete that from the sheet database as well. If you do not want to give them the add-in file, you can write additional code that runs on workbook open, to check for a username and password that can be stored in the hidden sheet. I hope this helps and thanks so much.
@@ExcelForFreelancers Hi Randy, thank you, if you can how will it work if I write extra code just for userid and password, how will it know what sheets are the person can use and so on. Is there a way even if I send them the add-in file, that they cannot change anything in it. I am a bit confused n this part
Kindly sir Make a Video for "Stationery Shop" like The Video Of "COFEE SHOP POS". please sir it's a request to you that makes a video on POS with Sales report and Inventory Management system fully Automatic for A Stationery Shop please.
Hi and thanks so much. You are welcome to download and customize the Coffee Shop POS for stationary. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
I spent a lot of time on your 7 year ago document. It was fine until I added sheets. It then went sideways as you said in this intro. Looking forward to this one. I do badly need this solved. Thank you.
I was trying to test this method and have a suggestion. Is there a way to show which user is logged in? Perhaps the user name at the top? Also when testing a particular workbook how can that workbook require a login at startup? Then if the credentials aren't correct the workbook can't be opened.
Hi and thanks very much Billy. Those are both great suggestions. I will do my best to get those features added on the Patreon/TH-cam Members update this Monday. Thanks again
Hi Randy, how could this work with using OneDrive to share the file and making sure every user has their own “sheet view” so that if filters or macros are being used this will only affect them? Cheers:)
Hi Glen, Thanks so much. Each user would use their OWN worksheet (not the same one) Only the data is shared between users using a shared folder, such as OneDrive. I show you how to do this in this video To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html I hope this helps and thanks so much.
Yes for sure. i have another training on that. To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html I hope this helps and thanks so much.
Just curious why my TH-cam displays Arabic text when I enable CC. Don't think it is my youtube setup. Anyting in the video uploads that does this setting?
Hi Malcom, in the TH-cam settings on the video, you can change the language. There are two icons (one for CC and one for Settings) so check your settings, then 'Subtitles' you can then set the language. I hope this helps and thanks so much.
![ILLSLICK - KILLSHOT REMIX [FULL VERSION]](http://i.ytimg.com/vi/RIK8RrqIAzE/mqdefault.jpg)
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
Yes.... the character issue bit me once and I am glad you fixed it by using chr() function rather than a hardcoded character.
Thanks so much. Yes that was my mistake many years ago so I have also learned. Thank you for your Likes, Shares & Comments. It really helps.
I want to thank you, Randy. I have been building our very own Mechanic Shop system off of your videos and I have learned so much. You make it simple to understand. Before I found you, I had no idea that vba was even a thing. Our shop is very small and you have everything we need! Keep up the great work!
Thank you so very much, I really appreciate that Amanda. I am super happy I can help and share. Thanks again for the great feedback
Persistence & hard work over the years definitely pays off. This is a fantastic Add-in ... Thank you Randy
Thanks so much Neren. I think you remember the original many years ago. A big change for sure. Thanks again for your continued support
Awesome work sir!
Thanks @Randy for the video,it's useful.
For sure, you are very welcome and I am very happy to help and share
Excellent add-in.
Thank you so very much, I really appreciate that Joe
Another Masterpiece from Randy...
Thank you so very much, I really appreciate that and so glad you enjoyed the training
You are king of excel vba
Thank you so very much, I really appreciate that and I am very happy to help and share.
Amazing thank you!
Thank you so very much, I really appreciate that and always love to see your feedback. Much appreciated
Thank you sir, really you are amazing in Excel. I have a question, Multiple user Can work on office 365 file at same time?
Hi and thanks so much. Yes for sure. Multiple users can work on the desktop version at one time. To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html
Wonderful work sir❤❤❤❤
Kindly guide me that which Version of Excel you are using for these Projects??? Please tell me the version.
I have many on projects. Please feel free to search my channel for "Project" I hope this helps and thanks so much.
Hello Randy,
Thank you for responding to my other comment. After getting my program set up, I did realize I do not know how to get the workbook to not close if the user is not logged out. VBA suggestions? Thanks again!
Hi and thanks very much Amanda. In the workbook events, you have a 'BeforeClose' event. In this event, you can write a small line of code. Something like
Private Sub Workbook_BeforeClose(Cancel As Boolean)
' Reference the worksheet, replace "SecSht" with your actual sheet name
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("SecSht") ' Update with the actual sheet name if different
' Check the condition in cell B2
If ws.Range("B2").Value = "Logged In" Then
MsgBox "Please make sure to log out before closing this workbook", vbExclamation
Cancel = True ' Cancel the close operation
End If
End Sub
I will add this to the update on Patreon for this Monday www.patreon.com/ExcelForFreelancers
@@ExcelForFreelancers That worked perfect! Thank you so much!
Thanks Amanda. I have also added this into the update, plus a ton more including user roles, prevent copy and paste, save as, drag and drop and a whole lot more for the update on Patreon in just a few days www.patreon.com/ExcelForFreelancers
Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, can you make when you choose a user, to select more than 1 sheet to do the security part
Hi Hendrik, thanks very much for your suggestion. I will do my best to get this added. Much appreciated
Hi Randy❤. Love your videos❤🎉🎉. Can you please please 🙏 add a hospital manager series like the school manager series with many features please ❤.thank you love from Tanzania, east Africa.
Hi and thanks very much. I would love to, but the large, multi-part videos get very low views, so I have to keep everything into a single video. I have a Clinic Manager, but not a Hospital Manager. Perhaps you can share some ideas and I will try to get the minimum # of features into a single video? What would you like to see?
Feel free to email me as well Randy@ExcelForFreelancers.com
Thank you for your Likes, Shares & Comments. It really helps.
Nice one
Hi Randy. Thanks a lot for the add-in. I watched the video and tried it. But it seems like everyone can edit the users' rights. I think only the admin should be able to do that. Or maybe I missed something?
Hi and thanks very much. On the Patreon Update I will be adding an 'Admin' role in which only those with Admin rights will be able to make edits. I will be releasing it this Monday here www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Thank you, Randy. Just a few questions I want to find out. 1. If I did have a sheet in my workbook and I delete it, it still show under my username, how to get rid of it. @. I I add a user and I gave him the workbook, will it work on his computer so he must input userid and password, as I do not give them the xlam file .
Thank you Hendrik. If you delete a sheet, the macro can run through all the sheets, check for deleted sheets and then delete that from the sheet database as well.
If you do not want to give them the add-in file, you can write additional code that runs on workbook open, to check for a username and password that can be stored in the hidden sheet. I hope this helps and thanks so much.
@@ExcelForFreelancers Hi Randy, thank you, if you can how will it work if I write extra code just for userid and password, how will it know what sheets are the person can use and so on. Is there a way even if I send them the add-in file, that they cannot change anything in it. I am a bit confused n this part
Hi Hendrik thanks very much. Its a great point. I will explain it in more detail on the Patreon update this Monday. thanks again
Kindly sir Make a Video for "Stationery Shop" like The Video Of "COFEE SHOP POS".
please sir it's a request to you that makes a video on POS with Sales report and Inventory Management system fully Automatic for A Stationery Shop please.
Hi and thanks so much. You are welcome to download and customize the Coffee Shop POS for stationary. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
If I were to Sign up for Patreon Silver, do I still get access to the additional trainings of past training such as this one?
I spent a lot of time on your 7 year ago document. It was fine until I added sheets. It then went sideways as you said in this intro. Looking forward to this one. I do badly need this solved. Thank you.
Hi and thanks, I really appreciate that and I am glad you enjoy the updated add-in. Thank you for your Likes, Shares & Comments. It really helps.
I was trying to test this method and have a suggestion. Is there a way to show which user is logged in? Perhaps the user name at the top? Also when testing a particular workbook how can that workbook require a login at startup? Then if the credentials aren't correct the workbook can't be opened.
Hi and thanks very much Billy. Those are both great suggestions. I will do my best to get those features added on the Patreon/TH-cam Members update this Monday. Thanks again
@@ExcelForFreelancers I am getting an extra sheet when adding user credentials.
Yes for sure, that is written in the code. Please make sure to watch the entire training for details on that. I hope this helps and thanks so much.
WOW PISAN pokonamah
Great, Thank you so very much, I really appreciate that
Sir i have already typed a comment but it was not showing now.Any problems with my comments sir?
Hi and thanks very much. I can see your comment here. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, how could this work with using OneDrive to share the file and making sure every user has their own “sheet view” so that if filters or macros are being used this will only affect them? Cheers:)
Hi Glen, Thanks so much. Each user would use their OWN worksheet (not the same one) Only the data is shared between users using a shared folder, such as OneDrive. I show you how to do this in this video To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html
I hope this helps and thanks so much.
Nice
Can multiple people open or work on it at same time?
Yes for sure. i have another training on that. To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html
I hope this helps and thanks so much.
How can i download 360 worksheet with pdf source code
HI and thanks so much. You can get it from here rebrand.ly/350Wkbks_Randy
I hope this helps and thanks so much.
Just curious why my TH-cam displays Arabic text when I enable CC. Don't think it is my youtube setup. Anyting in the video uploads that does this setting?
Hi Malcom, in the TH-cam settings on the video, you can change the language. There are two icons (one for CC and one for Settings) so check your settings, then 'Subtitles' you can then set the language. I hope this helps and thanks so much.