I'm working on a spreadsheet that was made by someone else at another company. My boss would like me to update it so that it applies to our current work. Problem is, there were command buttons at the top that were activated with some code to make them work. They won't work now that I've added some command buttons and I can't get the new command buttons to work. I need to be able to click on them and they sort by whatever they are labeled to do. PLEASE HELP!
Thank you,
Beth
why is that dangerous? it kept saying that on the tutorial, but no explanation why.why is that dangerous? it kept saying that on the tutorial, but no explanation why.
You can't post conmments that contain an email address.
Your Excel may have a different "Macro Security" setting.
Your "Macro Security" can be adjusted:
Tools, Macro, Security.
I highly recommend the "Medium" setting.
This will prompt you when an Excel file is opened that contains Macros to Enable or Disable.
If you choose a security setting of "Low" please be very careful as this will allow Macros to run without any notice, VERY DANGEROUS.
Because someone may send you an Excel file with Malicious code that can delete / rename / goober up your hard drive. There are old school DOS commands that can be activated with code without the users knowledge.Because someone may send you an Excel file with Malicious code that can delete / rename / goober up your hard drive. There are old school DOS commands that can be activated with code without the users knowledge.
You can't post conmments that contain an email address.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Enable macros in the Backstage view Another method to enable macros in a file is via the Microsoft Office Backstage view, the view that appears after you click the File tab, when the yellow Message Bar appears. Click the File tab. In the Security Warning area, click Enable Content. Under Enable All Content, click Always enable this document's active content. The file becomes a trusted document.
Your best bet for the best help is at www.remotecentral.com That's where the Pros hang out.. I do Crestron,Lifeware,RTI and Logitech, I don't do too many Universal's. They have a whole forum dedicated specifically to the MX remotes. Hope this helps
Try create a new Workbook (file) and then copy only the 10x200 cells from the NULL'ly spreadsheet. Unless you have macros in the nully one, it should be resolved by copying the needed cells to blank new file.
I have solution for your second problem. You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.
Macro is a simple way to automate tasks in Microsoft Office programs. It allows advanced users to program or create their own commands in Office, thereby automating tasks. For example, a user might want to create a table with four values already in them. The user could create one, and then copy it, and paste it. However, when you restart your computer, that data is lost. Unless you open the old document and copy the table, you'll have to start all over again. Macros helps you do your tasks. By recording the table creation to a macro, creating the same table over and over is just a simple macro away.
why is that dangerous? it kept saying that on the tutorial, but no explanation why.
×