Great way to not let others leech of your hard work!
@sumardjo
4 ай бұрын
Thanks to sample file I Have follow to video with your sample file thanks very much
@darrylmorgan
3 жыл бұрын
Really Like The Neat Little Trick Typing The Other Module And Period...Thank You Sir :)
@TeachExcel
3 жыл бұрын
I'm glad it was helpful, I almost cut that part out to make it shorter lol, but now I'm glad I didn't!
@wayneedmondson1065
3 жыл бұрын
Nice tips there! Very informative. Thanks for sharing :)) Thumbs up!!
@TeachExcel
3 жыл бұрын
Thanks Wayne! :)
@W00DY420
2 жыл бұрын
You just put the cherry on top of my macro exploit 😂 Thank you sir
@VillaOuk
3 жыл бұрын
Cool trick. Thank you
@TeachExcel
3 жыл бұрын
I'm glad you think so! You are very welcome :))
@hitorikun2191
8 ай бұрын
Hi. I know it's already 2 years ago since you've posted this video. *Option Private Module* does hide my macros which is what I wanted, the only problem I get is I couldn't run my macros with the shortcut keys. I tried other workaround here like making another macro to run my private macro, but that just negated the purpose of making my macros private beacuse I don't want other users to run my macros. And I just want to run my private macros with just a shortcut keys and no password.
@tapasvivyas957
2 жыл бұрын
superb bro.
@gabriela_sd260
Жыл бұрын
How to unhide the macro? I cannot reverse the operation. Thank you very much.
@gregwmanning
3 жыл бұрын
Gday, Not sure if you take questions but here goes. Downloading bank transaction put all amounts (positive & negative) in a single column, I want to move negative amounts to a new "Debit" column. I know how to make negative numbers easy to see by auto formatting with a red font. In a column of amounts how can I easily select just the negative values? Many thanks Greg
@TeachExcel
3 жыл бұрын
I smell Taxes lol. There are many complex ways, but this is what I do: Add a new column, use that column to ensure the numbers are actual numbers (my bank seems to export non numeric minus signs or dashes) > and then Filter the data and show only the negative values and select them and copy/paste them to a new column. There are many ways to do this and many formulas you can also use, but this is a quick-and-dirty way to do it and it works fine for me. If you have any more questions, you should ask them in the forum on TeachExcel for a faster response: www.teachexcel.com/talk/microsoft-office?src=yt_comment You will get a faster reply in the forum - here I don't always see the comments for older videos and it takes longer to respond.
@johnbutler2750
3 жыл бұрын
If you want to limit who can run macros, I like hard coding application.username and if none of those match the users exiting sub at start. This is handy if you have macros triggered by sheet clicks as eg
@TeachExcel
3 жыл бұрын
That's a nice one!!! What a great switch to use for that! Thanks for sharing it John!!
Пікірлер: 16