473,385 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Disabling the Sheets Unhide feature in Excel

AllusiveKitten
Hi All

I dont know if it is possible or not, but I am wondering if anyone knows if you can Disable the Unhide feature in Excel. The feature I am talking about is found under Format > Sheet > Unhide.

If this is possible I would love to be able to code this in..... it will keep little fingers from not touching what they shouldnt be.

Thank you for your assistance.
AK
Nov 6 '07 #1
6 2475
vinci
62
Disabling the "Unhide"?
Is the Sheet visible when the excel file will be opened?
because i think that when the sheet is visible the Unhide function will be definitely disabled...

Are you trying to say that you want the Unhide function disabled when the sheet is hidden?

cheers!
Nov 6 '07 #2
Hi Vinci
Disabling the "Unhide"?
Is the Sheet visible when the excel file will be opened?
No the sheets are not visible, I have the sheets hidden when excel opens, I have commands the user presses to enter their password before the sheet will become visible.

Are you trying to say that you want the Unhide function disabled when the sheet is hidden?
Yes I am trying to say I want the Unhide function diabled when the sheet is hidden, I want the Unhide function disabled when this paticular spreadsheet is opened full stop..

Hope this helps

Cheers
AK
Nov 6 '07 #3
vinci
62
i think its impossible...

let me first try with my aplication...


but if you were able to disable it, let me know! thanks... :D
Nov 8 '07 #4
i think its impossible...

let me first try with my aplication...


but if you were able to disable it, let me know! thanks... :D
Hi Vinci,

I have had no luck in working it out, your help would be greatly appreciated.

Thank you
AK
Nov 8 '07 #5
By protecting the workbook completely the unhide is disabled as well. Just make sure that you have not locked the cells the user should work on.
Nov 8 '07 #6
By protecting the workbook completely the unhide is disabled as well. Just make sure that you have not locked the cells the user should work on.
Thank you Tequila, that works a treat.
AK
Nov 8 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Ilan | last post by:
Hi all I need to add data from two Excel sheets (both on the same workbook) to an existing table in my SQL DB. The problem is that each sheet holds different fields for the same record, though...
2
by: Osiris Sawiris | last post by:
I inherited an Inventory control application that updates the stock from the branches at the end of each day. We receive the stock transactions via e-mail attachments (Excel Sheets). Those...
4
by: sunilkeswani | last post by:
I need help with exporting data from 2 access tables, into 2 existing spreadsheets in a single Excel file. Currently, I am using this code: DoCmd.TransferSpreadsheet acExport, 8, "Table1",...
4
by: Hitesh | last post by:
Hi, I have three datagrid control on my aspx page and one export to excel button, i want to export all the 3 datagrids contents in one excel file. how can i achive that? -- Thanks Hitesh
2
by: TJ | last post by:
Hi, Basically, I want to create excel file on the fly, then force users to download it without using automation. Here is one of ways.. System.IO.StringWriter sw = new...
0
by: acarrazco | last post by:
Hello, I am totaly new to VBA and I'm trying to modify a macro that was given to me but it doesn't seem to be working. I'm trying to extract data from three excel spreadsheets, put it into a combined...
2
nev
by: nev | last post by:
first of all, i'm not sure if this is the correct forum to post this question. please move if ever. the reason i placed it here is because you can create visual basic code in excel. i don't know...
4
by: Harshe | last post by:
hello all, I am trying to code, but i am just stuck after importing one sheet. so here is the gist of what i need help with. In a workbook at the start of the year (january) i will have 4...
2
by: deve8ore | last post by:
Hello, I'm working with Adobe Reader 8.0, working on a project for work, so not allowed to download any other software/ freeware. We receive PDF files frequently with about 20 sheets. I'd like...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.