ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VB Protection problem (https://www.excelbanter.com/excel-worksheet-functions/56856-vbulletin-protection-problem.html)

Rmagic

VB Protection problem
 

Hello

I have a workbook that i have protection on the sheets and workbook,
but the problem is with the VB i use the protection in the tools menu
it works fine
But when you close the workbook excel closes but a small input window
stays on the desktop asking for the pass word for the password (my VB
code) and if you click cancel it stay there, i have to type in the pass
word before it will go but the code or vb does not appear it just gets
rid of the input window

Stange

Any ideas


--
Rmagic
------------------------------------------------------------------------
Rmagic's Profile: http://www.excelforum.com/member.php...o&userid=28595
View this thread: http://www.excelforum.com/showthread...hreadid=487373


Dave Peterson

VB Protection problem
 
You have one reply at your other post.

Rmagic wrote:

Hello

I have a workbook that i have protection on the sheets and workbook,
but the problem is with the VB i use the protection in the tools menu
it works fine
But when you close the workbook excel closes but a small input window
stays on the desktop asking for the pass word for the password (my VB
code) and if you click cancel it stay there, i have to type in the pass
word before it will go but the code or vb does not appear it just gets
rid of the input window

Stange

Any ideas

--
Rmagic
------------------------------------------------------------------------
Rmagic's Profile: http://www.excelforum.com/member.php...o&userid=28595
View this thread: http://www.excelforum.com/showthread...hreadid=487373


--

Dave Peterson


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com