[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Del Hide Display

Posted on 2014-01-24
13
Medium Priority
?
192 Views
Last Modified: 2014-01-25
Hi expert,

Need to use this code for all users for all workbook - all sheets via quick access tool bar.

see attached file.



Thanks
Error-Remove.xlsm
0
Comment
Question by:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39806042
One more thing i want to protect the code by PassWord & while deleting button it create copy of sheet in same workbook with its actual formula. it is just for ,in case accidently click on delete tool bar.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39806260
ok no problem for the password
As for creating a copy I am afaird that this may be too cumbersome if each time a user click on delete you may endup with a lot of copies of formulas in case .... I think in my mind we can do the following:

When the user as to remove formulas then,
1) We ask for a confirmation question ... something like Are you sure you want to delete ... ?
2) Then we can built an Audit sheet and there put what we are deleting not a simple copy of the worksheet.

PLs confirm you want me to go this way or else pls comment.
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39806288
Yes it sounds more logical......
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 39806320
ok fine test this. Still the password which is no sweat will do at the end.

After you run it go at the Add-in menu and check the menu there. Check deletions in Audit sheet.

Let me know
gowflow
Err-Rem-Hid-Show-V01.xlsm
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39806326
thumbs Up   perfect...!!!!
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39806332
Now password & make every one on this pc use this feature.
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39806360
ok Sir gowflow password protected done by my self, make it global add in done only one thing in each & every time start up there is message box which is not requirednot Required


Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39806373
Well comment out this on the Module mAddmenus
MsgBox ("Menu created in Add-In Tab")

put a single quote ' at the very beginning it will turn Green then it will not execute this instructions. Save the workbook after you do this.

gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39806395
Sir will you give me some time to test as i am off the desk...


thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39806461
for sure. I am also off for sometime. see u later.
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39808359
Apology for late in reply from my side.

I had tested working fine.

For Password - this things done - VBA Window - Tools - Project properties - Protection - Lock Project.

For every one use save as Excel Add-In which saves file in Microsoft AddIn Folder.

is that right thing I had done?


Now issues while removing error messages from different workbook .it doesn't create Audit Sheet.

Rest all working fine

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39808370
yes for sure you went too fast. I gave you the solution with the menu but still it is not adapted to work as an addin we need to change things around. For the addin we need to set it up differently. I suggest you post a new question and will deal with at separately.
gowflow
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 39808381
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question