disable shortcut key sheet tab

[kalpesh]

Hello

i work in worksheet
now i would like to disable shortcut key "ctrl + s" & also hid
sheet tab by macro onl

how it

 

[Gord Dibben]

In Thisworkbook module enter this code to cancel CTRL + s

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
Cancel = True
End Sub

I note you have some sort of project being built which requires hiding
sheets and security issues but you reveal only one piece at a time.

Some of your questions are redundant.

Why not give a few more details and outline your project?

Might be there are easier ways to put it all together.



Gord

 

[GS]

Gord Dibben formulated on Saturday :

I note you have some sort of project being built which requires hiding
sheets and security issues but you reveal only one piece at a time.

Some of your questions are redundant.

Why not give a few more details and outline your project?

Might be there are easier ways to put it all together.

I agree! Looks to me like the OP doesn't have a project 'plan' but
rather is making it up as the project develops.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Vacuum Sealed]

Gord Dibben formulated on Saturday :

I agree! Looks to me like the OP doesn't have a project 'plan' but
rather is making it up as the project develops.

Going one step further gent's, I would almost say the OP is a student
and these are question within a textbook environment hence the reason
there is no structure to it.

Mick.

 

[Gord Dibben]

You may be onto something Mick but I would tend to agree with GS about
developing without a plan and running into obstacles along the way.

I notice no responses to any suggestions given by Isabelle, myself and
others.


Gord

 

[GS]

After serious thinking Vacuum Sealed wrote :

Going one step further gent's, I would almost say the OP is a student and
these are question within a textbook environment hence the reason there is no
structure to it.

Mick.

Mick, you might be right. I wish I had taken some courses in Excel so I
could recognize course material when I see it. I see where others have
hit on this exact same thing and I don't have a clue how they were able
to catch it...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

Gord Dibben pretended :

I notice no responses to any suggestions given by Isabelle, myself and
others.

Gord, there's a few who frequent this NG that don't respond to
solutions given. They do play back and forth, I notice, up to that
point but then that's the last we see of them on that topic.

Also, some use multiple user IDs so we don't catch on (or so they hope.
Fortunately, my newsreader also displays the poster's IP address and so
this is an easy catch for me)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Vacuum Sealed]

After serious thinking Vacuum Sealed wrote :

Mick, you might be right. I wish I had taken some courses in Excel so I
could recognize course material when I see it. I see where others have
hit on this exact same thing and I don't have a clue how they were able
to catch it...

Thx Garry & Gord

Actually, I haven't done any classes or courses at all, apart from
pouring through literary material, to date everything I have learned in
both Excel & Access has been through determination to understand what
lays in front of me, and of course the invaluable assistance given so
freely by your good selves.

With regards to my comments re the poster, my logic was telling me it
just seemed to me as there was no structure or pattern in the way there
was never a specific purpose behind posts.

And finally, I may be a tad old fashioned
(being a baby boomer), but it irritates the crap out of me when some
posters have affront to come here asking for help and don't have the
decency to thank those here that do so, so freely.

Keep up the great work guy's, it is sincerely appreciated by most...

Mick.

 

[GS]

Vacuum Sealed has brought this to us :

Thx Garry & Gord

Actually, I haven't done any classes or courses at all, apart from pouring
through literary material, to date everything I have learned in both Excel &
Access has been through determination to understand what lays in front of me,
and of course the invaluable assistance given so freely by your good selves.

With regards to my comments re the poster, my logic was telling me it just
seemed to me as there was no structure or pattern in the way there was never
a specific purpose behind posts.

And finally, I may be a tad old fashioned
(being a baby boomer), but it irritates the crap out of me when some posters
have affront to come here asking for help and don't have the decency to thank
those here that do so, so freely.

Keep up the great work guy's, it is sincerely appreciated by most...

Mick.

Thanks, Mick. I too learned much of what I know in similar fashion.
Nothing old fashioned about being a baby boomer <IMO, I'm one too (born
1950), or at least I consider myself one.

I appreciate your words of encourage, though, as I'm sure Gord does
too...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion