disable shortcut key sheet tab
 

Hello,

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

how it

disable shortcut key sheet tab
 

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


On Sat, 18 Feb 2012 12:40:14 -0600, kalpesh
wrote:

Hello,

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

how it

disable shortcut key sheet tab
 

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

disable shortcut key sheet tab
 

On 19/02/2012 8:12 AM, GS wrote:
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.


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.

disable shortcut key sheet tab
 

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

On Sun, 19 Feb 2012 11:03:34 +1100, Vacuum Sealed
wrote:

On 19/02/2012 8:12 AM, GS wrote:
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.


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.

disable shortcut key sheet tab
 

After serious thinking Vacuum Sealed wrote :
On 19/02/2012 8:12 AM, GS wrote:
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.


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

disable shortcut key sheet tab
 

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

disable shortcut key sheet tab
 

On 19/02/2012 1:31 PM, GS wrote:
After serious thinking Vacuum Sealed wrote :
On 19/02/2012 8:12 AM, GS wrote:
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.


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...

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.

disable shortcut key sheet tab
 

Vacuum Sealed has brought this to us :
On 19/02/2012 1:31 PM, GS wrote:
After serious thinking Vacuum Sealed wrote :
On 19/02/2012 8:12 AM, GS wrote:
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.


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...

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